Problem Note 34461: A system abend occurs when you include a libref that uses the DB2 engine along with a pass-through query
 |  |  |  |
In the z/OS environment, the following system abend occurs when you include a libref that uses the DB2 engine along with a pass-through query to DB2:
ERROR: System abend 0C4 occurred in module SASIODB2 function D2GET at
offset 0005DA.
ERROR: Traceback will be attempted...
NOTE: Traceback called
NOTE: Module Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASXDBI FETCH 0007BC 0
NOTE: SASSQX @@244537 0002B0 0 sqxextr_get_next
NOTE: SASSQX @@257242 0001CC 0 sqxslct_get_next
NOTE: SASSQX @@257228 0017A6 0 sqxslct_open
NOTE: SASSQX @@257214 000182 0 sqxslct_init
NOTE: SASSQX SQXEXEC 00012A 0
NOTE: SASSQX SQLLOOP 000BA8 0
NOTE: SASSQL SASSQL 000302 0
NOTE: SASHOST UNKNOWN 002DC0 0
ERROR: Delete current task.
This problem occurs when the pass-through query uses a CAST function to shorten the length of the value that is stored in a variable. The abend will occur, for example, if a variable contains the value ABCD and the CAST function includes the CHAR(2) data type, as shown here:
cast(value-expression as char(2))
As a workaround, use the SUBSTR function.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.1 TS1M3 SP4 | 9.2 TS2M3 |
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2009-01-15 10:15:57 |
| Date Created: | 2009-01-13 15:03:13 |